FirstPlace
Business Associates

Power BI

About Power BI Course

Power BI is a radically new tool in the hands of business enterprises who are overwhelmed with the amount of data at hand and until now did not have a cost-effective tool to extract insights from it. Enter Power BI which is a set of tools and applications that let you extract data from multiple unrelated sources and convert it into neatly managed and coherent set of information, visually appealing insights, interactive data, charts, graphs and reports.

What you will learn in this Power BI Training Course?

• Get an in-depth understanding of Power BI and how it works in different scenarios
• Learn about the three vital components - the Desktop, service, and Mobile apps
• Visualize and analyze data, derive insights from Excel spreadsheet or local database
• Create compelling reports, visualizations, derive real-time insights and deploy it on demand
• Create, share, collaborate and benefit from business information with purpose-built dashboards
• Know how to get work done without being a Business Intelligence professional
• Use Salesforce Data, Azure SQL Database & SQL server analysis tabular data
• Deploy content packs to work with Quick Books online and Adobe analytics
• Complete live Projects on Power BI to get hands-on experience.

Who should take this Power BI Training Course?

• Individuals looking for jobs as Business Analysts, Business Development Manager, etc
• Statisticians aiming to implement their statistics skill to derive business insights
• Marketing, Finance, Sales, and other domain individuals who need extensive business intelligence.

What are the prerequisites for taking this Training Course?

You don’t need any prior knowledge to benefit from this Power BI training.

Why should you take this Power BI Course Training?

• Global Business Intelligence and Analytics Market to Reach $16.9 Billion in 2016 – Gartner
• 70% of leading companies say analytics are integral to how they make decisions – IBM Survey
• A Senior Business Intelligence Analyst can earn $89,000 in the United States – Payscale.com

Today every business enterprise and department needs extensive business insights and Power BI puts the power in your hands. You can easily work with multiple sources of data, convert it into a report, graph, or data visualization of your choice. Get real-time insights and deploy it faster than any other BI tool available in the market. It is open source and highly intuitive and does not need technical knowledge or IT support. This Training will prepare you for the top paying jobs in the market and help you grow your career at a rapid pace.

Power BI Course Content

Introduction to Power BI

Introduction to Microsoft Power BI, the key features of Power BI workflow, Desktop application, BI service, and file data sources, sourcing data from web (OData, Azure), building dashboard, data visualization, publishing to cloud, DAX data computation, row context, filter context, Analytics Pane, creating columns and measures, data drill down and drill up, creating tables, binned tables, data modeling and relationships, the Power BI components like Power View, Map, Query, Pivot, Power Q & A, understanding advanced visualization.

Hands-on Exercise – Demo of building a Power BI dashboard, Source data from web, Publish to cloud, Create power tables

Extracting Data

Learning about Power Query for self-service ETL functionalities, introduction to data mashup, working with Excel data, learning about Power BI Personal Gateway, extracting data from files, folders and databases, working with Azure SQL database and database source, connecting to Analysis Services, SaaS functionalities of Power BI.

Hands-on Exercise Connect to a database, Import data from an excel file, Connect to SQL Server, Analysis Service, Connect to Power Query, Connect to SQL Azure, Connect to Hadoop

Power Query for Data Transformation

Installing Power BI, the various requirements and configuration settings, the Power Query, introduction to Query Editor, data transformation – column, row, text, data type, adding & filling columns and number column, column formatting, transpose table, appending, splitting, formatting data, Pivot and UnPivot, Merge Join, relational operators, date, time calculations, working with M functions, lists, records, tables, data types, and generators, Filters & Slicers, Index and Conditional Columns, Summary Tables, writing custom functions and error handling, M advanced data transformations.

Hands-on Exercise Install PowerBI Desktop and configure the settings, Use Query editor, Write a power query, Transpose a table

Power Pivot for Data Modeling and Data Analysis Expression – DAX Queries

Introduction to Power Pivot, learning about the xVelocity engine, advantages of Power Pivot, various versions and relationships, strongly typed datasets, Data Analysis Expressions, Measures, Calculated Members, Row, Filter & Evaluation Context, Context Interactions, Context over Relations, Schema Relations, learning about Table, Information, Logical, Text, Iterator, Table, and Time Intelligence Functions, Cumulative Charts, Calculated Tables, ranking and rank over groups, Power Pivot advanced functionalities, date and time functions, DAX advanced features, embedding Power Pivot in Power BI Desktop.

Hands-on Exercise Create a Power Pivot Apply filters, Use advanced functionalities like date and time functions, Embed Power Pivot in Power BI Desktop, Create DAX queries for calculate column, tables and measures

Data Visualization with Analytics

Deep dive into Power BI data visualization, understanding Power View and Power Map, Power BI Desktop visualization, formatting and customizing visuals, visualization interaction, SandDance visualization, deploying Power View on SharePoint and Excel, top down and bottom up analytics, comparing volume and value-based analytics, working with Power View to create Reports, Charts, Scorecards, and other visually rich formats, categorizing, filtering and sorting data using Power View, Hierarchies, mastering the best practices, Custom Visualization, Authenticate a Power BI web application, Embedding dashboards in applications

Hands-on Exercise Create a Power View and a Power Map, Format and customize visuals, Deploy Power View on SharePoint and Excel, Implement top-down and bottom-up analytics, Create Power View reports, Charts, Scorecards, Add a custom visual to report, Authenticate a Power BI web application, Embed dashboards in applications, Categorize, filter and sort data using Power View, Create hierarchies, Use date hierarchies, use business hierarchies, resolve hierarchy issues

Power Q & A

Introduction to Power Q & A, intuitive tool to answer tough queries using natural language, getting answers in the form of charts, graphs and data discovery methodologies, ad hoc analytics building, Power Q & A best practices, integrating with SaaS applications

Hands-on Exercise Write queries using natural language, Get answers in the form of charts, graphs, Build ad hoc analytics, Pin a tile and a range to dashboard

Power BI Desktop & Administration

Getting to understand the Power BI Desktop, aggregating data from multiple data sources, how Power Query works in Power BI Desktop environment, learning about data modeling and data relationships, deploying data gateways, scheduling data refresh, managing groups and row level security, datasets, reports and dashboards, working with calculated measures, Power Pivot on Power BI Desktop ecosystem, mastering data visualization, Power View on Power BI Desktop, creating real world solutions using Power BI

Hands-on Exercise Configure security for dashboard Deploy data gateways, Aggregate data from multiple data sources, Schedule data refresh Manage groups and row level security, datasets, reports and dashboards, Work with calculated measures

Power BI Projects

Project 1 : Top down and Bottoms up analysis to identify shipping costs leakages

Source : Adventure Works Online Sales

Topics : In this Power BI project you will on the analysis of shipping cost leakages by building stellar BI visualizations. You will identify the outliers in the data pattern using top down analysis and flip some of the visualization data in order to perform bottom up analysis.

Project 2 : Value & Volume based analysis on hospital records to analyze Charges vs. Patients Inflow

Source : Country wide hospital inpatients records

Topics : This Power BI project is involved with working on hospital patient records in order to analyze the billing charges vs. the number of patient admissions. You will build a set of visualizations that is linked to the dynamic measures in order to flip some analytics from top down to bottom up on demand in order to get the desired insights.

Project 3 : Understanding customer buying habits in automobile industry.

Industry : Automobile

Problem Statement : A leading automaker wants to make its new model of car a major success by using business intelligence tool Power BI.

Description : This project involves deploying the powerful business intelligence tool Power BI for an automobile enterprise. The customer buying habits, the reaction and feedback of customers to the new model of car need to be made sense of. You will deploy the powerful data mashup engine of Power BI to connect to different types of data, deploy self-service data analytics, and finally visualization it through powerful reporting for gaining business insights.

Highlights :

• Deploying Power BI on-premise or in the cloud
• Work with Power BI data mash-up engine
• Create compelling Power BI dashboard.

Project 4 : Media Company wants to understand customer’s behavior

Industry : Media and entertainment

Problem Statement : Getting to understand customers across media channels and tailor-making television programs for them.

Description : In this project you will learn how a large media company having millions of customers watching its television programs across channels is getting to understand the customer mindset. The company is deploying Power BI to make sense of customer viewing habits, the time that customers consume media per day, what are the demographics of the customers, what are the programs that they like and dislike. All this can be made sense of by deploying a powerful business intelligence tool like Power BI.

Highlights :

• Aggregating data from across the spectrum
• Combining data using data mash-up engine
• Modeling the data and deploying visualization.