Program features:
A 6-week training & implementation program which covers “Implementation challenges”
Covers 60 assignments (week 1-3(15 days-daily 4)
Going to cover 3 project implementations ,2 weeks (4/5-3 implementations)
Conduct evaluation of assignments with projects ,3 mock interviews
Resume preparation help with Roles & responsibilities
Environment configuration for SQL Server/Visual Studio/Power BI
Certificate of Completion will be awarded / we can do refer over call /through mail for employment which ever required.
Can give end to end knowledge of Power BI (desktop/service/mobile/DAX) will be covered.
7AM -10 PM Contact center support for any emergency support
As Power BI Guru is consulting partner in some companies in India/Dubai, Qualified profiles can be processed on Power BI Guru pay roll based on customer need.
100% Job Assistance will be covered (through live implementations/assignments/mock interviews/ resume preparation help/Resume processing)
Prerequisites:
Windows 10 /64bit OS
Good internet connection
Week 1:
Day 1:
Introduction to internship Program
Introduction to Power BI
Products of Power BI
Installation of Power BI
Walkthrough of POWER BI desktop
Day 2:
Working with Data sources
Different types of storage types /modes
Difference b/w import /direct Query /live connection
Working with SQL Server/SSAS/Excel/CSV
Day 3: Working with Visualizations
Understanding of tool tips
Configuration of Line/bar charts /table and matrix visuals
Day 4:
Configuration of Pi/Daunt /slicer/gauge/card/map visuals
Day 5:
Remaining default visuals
Working with custom visuals
Day 6:
Working with UI-Drill down visuals
Drill through
Filters
Day 7:
Cross filtering
Alignment of visuals
Bookmarks
Sync Slicers
Data drill/format tabs remaining options
Day 8:
Security implementation
Row level /row based security
Day 9
Introduction to Dax
Measure /column /table/quick measure /what if
Day 10:
Home tab
View tab
Help/modeling remaining options
Day 11:
Data cleaning
Working with Grouping
Pivot PwC
-
Un pivot Splitting
Appending
Merging
Day 12:
Adding a column
Removing duplicates
Filtering
Order by
Having
Transformations Number/string/date /time
Day 13:
Configuring Power BI service
Publishing a report
Configuring gateways
Performing a scheduled refresh
Creating a report
Day 14:
Creating a dashboard
Configuring subscription
Configuring Alerts
Embedding
Understanding of publishing
Day 15:
Working with DAX functions Part 1
Filter
Sum
Sum x
If
Is blank
Contains
Look up value
Related
variables
Day 17:
Dax functions part 2
Calculate
All
All Except
Summarize
YTD
MTD
QTD
YOY
Username
Day 18 /Day/19/day 20-25 days
Project 1-3 Day 26-30
Evaluation of projects
Mock interviews
Resume building
