1st lesson free
The profile of Lavanya and their contact details have been verified by our experts
Lavanya
- Rate TSh 46,178
- Response 1h
-
Students2
Number of students Lavanya has accompanied since arriving at Superprof
Number of students Lavanya has accompanied since arriving at Superprof
TSh 46,178/hr
Contact
1st lesson free
- Databases
Senior Data Analyst | Power BI | Qlik Sense | SQL SSMS. From scratch to advanced levels.
- Databases
Lesson location
About Lavanya
I'm Lavanya Ilango, a Sr Data Analyst with around 7 years of experience with great exposure to Power BI, Qlik and SQL.
I have a proven track record in data cleansing, preprocessing, mapping, modeling, and visualization. I recognize myself as an expertise in Data Modeling, Cleansing, report generation, creating Stored Procedures/ views with great attention to detail, providing high quality business solutions to complex Problems.
I enjoy mentoring and training individuals in Power BI, helping them to understand and harness its full potential. My approach is practical and tailored to the learner's needs, ensuring they can effectively apply their new skills in real-world scenarios.
I'm passionate about teaching and look forward to helping others master Power BI. Thank you for considering me for this tutoring opportunity.
See more
About the lesson
- Primary school
- Ordinary Level
- Form 5
- +10
levels :
Primary school
Ordinary Level
Form 5
Ordinary Diploma
Tertiary Education
Adult Education
Master’s Degree
MBA
Nursery
Beginner
Intermediate
Advanced
Children
- English
All languages in which the lesson is available :
English
Unlock the Power of Data with Comprehensive Power BI Training!
Are you eager to dive into the world of data analysis and visualization? Do you want to become proficient in Power BI and excel as a Data Analyst? Look no further! With my 7 years of industry experience, I offer personalized, one-on-one Power BI tutoring that will transform you from a beginner to an advanced user capable of handling real-world industry projects.
Why Choose My Power BI Lessons?
1. Customized Learning Experience:
o Tailored sessions that align with your current knowledge and learning goals, until you understand.
o Flexible scheduling to fit your busy lifestyle.
2. Comprehensive Curriculum:
o Covering everything from the fundamentals to advanced Power BI techniques.
o Hands-on projects and real-world scenarios to enhance your learning experience.
3. Industry Expertise:
o Learn from a seasoned Data Analyst with 7 years of industry experience.
o Gain insights into industry best practices, Sample Data and practical applications.
4. Interactive and Engaging Sessions:
o Live demonstrations and interactive exercises to reinforce your understanding.
o Q&A sessions to address your specific questions and challenges.
5. Practical Skills Development:
o Develop the skills to create stunning data visualizations and insightful reports.
o Master data modeling, Power Query Editor, DAX (Data Analysis Expressions), and Power BI Desktop.
6. Career Advancement:
o Build a strong foundation to advance your career as a Data Analyst.
o Prepare for real industry projects and stand out in the job market.
What You'll Learn:
1. Introduction to Power BI
• Overview of Power BI
• Power BI Desktop, Service, and Mobile Apps
• PBI Architecture - 3 sectors of PBI development
2. Power Query Editor
• Get Data (Excel, SQL Server, Web, etc.)
• Data Cleansing and Transformation – Home, Transform, Add Column
• Data QA and Profiling Tools
• Transformation and Preparation – Text, Numerical tools, etc.
• Storage Modes – Import, Direct Query, Composite, Live
• Types of Data Load – Incremental, Full, Streaming, Hybrid
• Master Calendar
• Rolling Calendar
• Index and conditional columns
• Grouping and Aggregation
• Merging and Appending
• Folder for Appending Files
• Data Source Settings
• Parameters
• Data Refresh
• Query Folding
• Importing Excel Models
• Vertipaq
• PQE Best Practices
3. Data Modeling
• Normalization
• Fact and Dimension Tables
• Primary and Foreign Key
• Relationships
• Cardinality
• Cross filtering
• Star and Snowflake Schemas
• Link / Bridge Table
• Model Layouts
• Hierarchies
4. DAX (Data Analysis Expressions)
• Introduction to DAX
• Calculated Columns
• Measures
• Implicit vs Explicit Measures
• Quick Measures
• DAX Functions
o Math and Stats
o Logical
o Text
o Filter
o Table
o Date & Time
o Relationship
• Dedicated Measure Table
• Context in DAX (Row Context vs. Filter Context)
• Iterator Functions
• Qualified and Unqualified
• Calculated Tables
• Calculation Group
• Dax and M Language
• Variables in DAX
• DAX Optimization Techniques and Best Practises
5. Visualization
• Report Introduction and Interface
• 3 Key Questions
• Creating and Customizing Visuals
o KPI
o Bar
o Line/Area
o Pie/Donut
o Slicers
o Filters
o Map
o Scatter, etc.
• Conditional Formatting
• Top N
• Drill-Up and Drill-Down
• Naming and Grouping objects
• Cards and multi row cards
• Tooltips
• Forecast
• Button Navigation
• Drill-Through
• Edit Interaction
• Bookmarks
• Numeric Range Parameters
• Field Parameters
• RLS – Statis, Dynamic
• OLS
• Mobile Layouts
• Publishing
6. Artificial Intelligence
• Anomaly Detection
• Smart Narratives
• Q&A visuals
• Decomposition Trees
• Key Influencers
7. Optimization
• Best Practices for Data Modeling
• Using Aggregations and Summarizations
• Reducing Data Model Size
• Optimize Ribbon
o Pausing Visuals
o Optimization Presets
o Applying all slicers
o Performance Analyzer
8. Best Practice's
See more
Rates
Rate
- TSh 46,178
Pack prices
- 5h: TSh 230,890
- 10h: TSh 461,781
online
- TSh46,178/h
Travel
- + TSh 20
free lessons
The first free lesson with Lavanya will allow you to get to know each other and clearly specify your needs for your next lessons.
- 1hr
Similar Databases teachers in Calgary
Ammar
Montréal, Canada & Online
- TSh 46,303/hr
- 1st lesson free
Esmaeil
New York, United States & Online
- TSh 78,831/hr
- 1st lesson free
Billy
Bullhead City, United States & Online
- TSh 131,384/hr
- 1st lesson free
João
New York, United States & Online
- TSh 65,692/hr
Diego
London, United Kingdom & Online
- TSh 65,929/hr
- 1st lesson free
Ryan
Victoria, Canada & Online
- TSh 111,127/hr
- 1st lesson free
Joshua
Dorval, Canada & Online
- TSh 92,606/hr
Massimiliano
Ancona, Italy & Online
- TSh 89,697/hr
- 1st lesson free
Jordan
Jedburgh, United Kingdom & Online
- TSh 104,098/hr
- 1st lesson free
Nikhil
Dublin, Ireland & Online
- TSh 146,505/hr
- 1st lesson free
ELMEHDI
Paris 19e, France & Online
- TSh 29,899/hr
- 1st lesson free
Aniket
Bengaluru, India & Online
- TSh 83,269/hr
- 1st lesson free
Pedro
Ciudad de México, Mexico & Online
- TSh 29,232/hr
- 1st lesson free
Priyanshu
London, United Kingdom & Online
- TSh 138,797/hr
- 1st lesson free
Sumit
London, United Kingdom & Online
- TSh 346,994/hr
Callum
Caboolture, Australia & Online
- TSh 163,034/hr
Dr Smit
Fortitude Valley, Australia & Online
- TSh 108,689/hr
João
London, United Kingdom & Online
- TSh 104,098/hr
Andrei
California City, United States & Online
- TSh 131,384/hr
- 1st lesson free
Diego
Pieve Emanuele, Italy & Online
- TSh 74,747/hr
- 1st lesson free
-
See Databases tutors
