Classified Details

Power Bi Online Training At Www.futurepointtech.com

  • Classified Details :

    Scope Topic Introduction 1. Introduction to Power BI and Power BI Products. Also, pricing of Power BI 2. Installing Power BI desktop and sign-in to Power BI app service from Desktop Desktop App Service 3. Explore the Power BI Desktop panels i. Options window (left to Home Menu) ii. Top Ribbon with different data sources ii. Left side vertical panel iv.Right side vertical panels (Visualizations, Fields) Data Cleansing 4. Explore all the data sources and connecting to excel file, text file, folder source, sql server database 5. What is Load and edit? Can we do edit after loading to the model? 6. HOME ribbon I) Choose & Remove columns ii) Keep & remove rows iii) Remove duplicates & Error rows iv) Sorting v) Split column (by delimiter / by no. of characters) vi) Group by vi) data type change vii) First row as headers viii) Replace values ix) Merge queries & Append Quires Transform ribbon i) Transpose, Reverse and Count Rows ii) Fill iii) Pivot and Un-pivot iv) Format v) Merge columns and Extract vi) statistics / standard/ Scientific / Trigonometry / Round/ Information vi) Date/ Time / Duration Add Column ribbon Add Custom columns / Index column View ribbon i) Query settings ii) Advanced editor iii) Formula bar (M-Query) iv) Mono spaced v) Show whitespace Left / RightPanels i) Left side vertical panel (Queries) Table and options ii) Left side vertical panel (Query settings) Properties and Applied steps with gear icons 7. How to load the cleansed and transformed data to the data model (Close and Apply option)? Data Modelling 8. What is relationship window and Data window from Left side vertical panel 9. Relationship window  Explore Table properties and Field properties & manage relationships from ribbon Data window Explore the field properties from the right side vertical panel (Fields) Difference between new measure & New columns 10. Create multiple measures and columns with DAX functions Reports 11. What is reports windows from Left side vertical panel and explore the options of reports window i. Top ribbon with report options  New page, visuals, Text box, image, shapes and page view ii. Right side panel(Fields options) Rename, hide/Unhide, delete, Hierarchy and filters (Visualizations) around 25+ styles with formatting options 12. Different report styles and apply formatting options i. Table, Matrix, Card, Multi row card, ii. Bar charts, Line charts iii. Dual style charts (Line and bar) iv. Pie charts, Donut charts, Tree maps and geographical maps (Globe and Filled Map) v. Scatter plot, Funnel, Gauge, KPI and Slickers. vi. R based charts 13. After adding 4 visuals to page, explore the below options i. Ribbon (Home)  Format painter ii. Ribbon (Format) Edit interactions, Align, distribute and bring forward, send backward iii. Visual options Focus mode, sort by, export data 14. How to create drilldown charts? 15. How to publish the files Power BI App service and what are the options while publishing? 16. Explore Power BI App service window with top ribbon and panels i. Top black ribbon 1. Full focus mode with print option while in focus mode option 2. Gear iconContent packs, settings, gateways, Dev tools and embed code 3. Downloads, support, feedback and account info ii. white ribbon under black ribbon 1. Add widget (Web content, image, video and Textbox) 2. Share 3.  Duplicate / print / refresh/ featured dashboard iii. question bar below white ribbon provide business question, answered in a report format iv. Left side ribbon (from bottom) 1. Datasets: Explore data set options Gateways 17. Types of gateways and what are those? 18. refresh the data from on-premise to Cloud App service Help Help Links 1. Power Bi Desktop help - https://support.powerbi.com/knowledgebase/articles/567183-power-bi-designer-help 2. Power Bi Get started- https://support.powerbi.com/knowledgebase/topics/63037-getting-started 3. Power Bi- General updates (GA) for every month -http://blogs.msdn.com/b/powerbi/archive/2015/09/23/44-new-features-in-the-power-bi-desktop-september-update.aspx 4. Power Bi Software links-https://powerbi.microsoft.com/downloads 5. Power BI Blog-http://blogs.msdn.com/b/powerbi/ 6. Power BI on-premises third party hosting serverhttps://powerbi.microsoft.com/landing/pyramid Courses Offerings Amazon Web Services Android AIX Administration Business Analyst Build and Release CA Siteminder CCNA, CCNP Security, CCIE , CheckPoint Citrix XenApp Cognos 10 BI & Tm1 Crystal Reports Data Stage DB2 DBA Dell Bhoomi Dev Ops Dot Net Ethical Hacking Google Web Tool Kit Golden Gate Hadoop Hyperion Essabase, Planning, HFR , HFM , DRM IBM Websphere Commerce server Admin IBM Lotus Notes (Development) IBM Lotus Notes Domino Server Administration IBM Message Broker IBM MQ Series Administration IBM Netezza DBA & Development IBM Tivoli Access Manager IBM Web Sphere Application Server Administration (WAS) IBM Websphere Transformation extender (WTX 8.2) IBM Integration BUS ( IIB ) Informatica I Phone Swift Language training Java/J2EE JAVA UI Java Apache Wicket Linux Administration training Mango DB MicroSoft .NET Technologies (VB.NET, C#, ASP.NET, Wcf ,Wpf ,Mvc) Microstrategy MicroSoft Business Intelligence OBIEE 11 g , 12c ODI ( Oracle Data Integrator) Openstack Oracle APPS - HRMS, SCM, Manufacturing , Technical , ASCP .Dmantra Oracle APPS - Project Accounting Oracle APPS - iProcurement , iSupplier, Sourcing OAF Oracle BI Apps Oracle BI Publisher Oracle DBA 11g Oracle RAC , Data Guard , Performance Tuning, Oracle Fusion SOA Oracle SQL , PL SQL People soft Functional and Technical PHP Perl Scripting Qlikview RSA Archer Security Operations Management (SecOps) Essentials RUBY Cucumber SAP SD , BO , FICO , BI / BW , APO , BPC, BASIS , SRM , MM, ISOil, BODS SAP Simple Finance SAS Sales Force CRM Service NOW SharePoint Server 2010 Shell Scripting SQL Server DBA Springs and Hibernate Storage Area Network ( SAN) Tableau Team Foundation Server Tera Data Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB TIBCO BW, BE, TIBCO I Process Tivoli Access Manager & Tivoli Storage Manager Unix & Linux Administration VMWare WCF, WPF, LINQ, AJAX, SILVER LIGHT Webservices , SOAP , REST ( JAVA) Windows 2012 server http://www.futurepointtech.com/microsoft-power-bi-training.html

    Posted On :
    February 05, 2017

    City :
    Gaya

    Category :
    Education

    Sub Category :
    Professional Courses

  • Advertiser Details

    Contact Name : Futurepoint
    Location : Gaya, India
    Mobile / Phone No: 9247765590
    Website Url : http://www.futurepointtech.com/microsoft-power-bi-training.html
    Posted Date : February 05, 2017
    Print this Page

  • Send Query to Advertiser

    verification image, type it in the box