Along with the Live instructor led training , you would be provided access to related eLearning training with lifetime access $200 value.
About this Event

Limited Time offer: Along with the Live instructor led training , you would be provided access to related eLearning training with lifetime access ( a $200 value)

https://elearning.bigdatatrunk.com/p/introduction-to-power-bi

https://elearning.bigdatatrunk.com/p/power-bi-hands-on

<h5>Short Description:</h5>

This course will introduce you to the Power BI (Business Analytics Tool, Power BI Desktop and Power BI Service, from Microsoft). This is 95% hands on training to build beautiful and informative dashboards and reports.

<h5>Long Description:</h5>

Excel with Power BI for Data Insights, Master Microsoft's Power BI, from Desktop to Service, with our hands-on course. Create stunning dashboards and reports while working on real-world projects: a Customer Demographics Report and a Financial Report. Learn data collection, cleaning, shaping, and analysis to uncover trends and insights. Dive into Power BI visuals, data modeling, and cloud publishing. No prior Power BI experience required – we'll guide you every step of the way. Sign up now to become a Power BI pro!

<h5>Course Code/Duration:</h5>

June 24th & 25th, 2024
2-Half Days (9:00 a.m to 12:00 p.m PST)

<h5>Learning Objectives:</h5>

Upon completing this course, you will accomplish the following objectives:

Power BI Installation
Master Power BI Desktop
Explore Power BI Service
Data Transformation
Custom Visualizations Effortless Business Intelligence
Collaboration and Sharing
Advanced Topics (if time permits)

Prerequisites

Basic knowledge of computers (Admin rights on your computer. If you do not have admin rights, please ask your administrator to go to https://powerbi.microsoft.com/en-us/desktop/ . Download Power BI desktop and Install it.)

Audience:

Data Analyst, SQL Developers, Database Administrator, Database Developers, Aspiring Data Warehouse Professionals

<h5>Course Outline:</h5>

Course Introduction
Overview Power BI
- Why Power BI
- Evolution of BI Stages
- User Workflow
- Power BI Lifecycle
- Natural Language Query
- Quick Insights
- Cortana Integration
- Live Dashboards
- Content Packs
- Power BI Platforms
Installation of Power BI Desktop
Basic Operations
Power BI Desktop Walk-thru
Working with Data
- Collecting data from text file
- Collecting data from Excel
- Collecting data from Databases
- Collecting data from Web (Web Scraping)
- Streaming data
Working with Power BI Query Editor
- Renaming columns
- Removing columns
- Removing Rows
- Make Row as header
- How to create calculate column by example
- How to create custom column
- How to create conditional column
- How to change data types
- How to replace values
- How to rearrange columns
- Merge queries
- Append queries
Power BI Visualizations
- Bar Charts
- Pie Charts
- Donut Charts
- Combo Charts
- Other Custom Charts
- Visuals Cards
- Visuals Gauges
- Visuals KPIs
- Visuals Tables
- Visuals Matrix
- And other custom visuals
Data Modeling
- Modeling Basics
- Modeling and Relationships
- Normalization – DE normalizations
- Star Schema vs Snowflake Schema
Hands on Real-world Projects
- Demographics report for Bank
- Finance report for Retailers
- Filters – Page – Report
Introduction to Dax
- What is Dax
- M vs Dax
- Rules to create Measures
- Calculate Columns vs Calculate Measures
- Common Dax functions
Power BI Service
- What is Workspaces
- What is Reports
- What is Datasets
- What is Dashboards
- How to create Workspaces
- Create Dashboards 6 different ways
- Favorite dashboards, reports and apps
- Dashboard menus
- Quick Insights
- Q-A in Power BI
- Analyze in Excel
- File and View Options
- Printing dashboards and reports
- Row Level Security
Sharing and Collaboration
- Sharing and Collaboration
- Sharing Dashboards
- Sharing Workspaces
- Sharing Apps
- Publish to web.