1^st class free

Lavanya

Rate ₹1,650
Response 1h
Students
Number of students accompanied by Lavanya since their arrival at Superprof
2
Number of students accompanied by Lavanya since their arrival at Superprof

₹1,650/hr

1^st class free

Databases
Data Analysis

Senior Data Analyst | Power BI | Qlik Sense | SQL SSMS. From scratch to advanced levels.

Databases
Data Analysis

Class location

- Online

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.

About the class

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

Rates

Rate

₹1,650

Pack prices

5h: ₹8,251
10h: ₹16,501

Travel

+ ₹20

free classes

This first free class with Lavanya will allow you to get to know each other and to specify the exact learning requirements for the upcoming classes.

online

₹1,650/hr

Senior Data Analyst | Power BI | Qlik Sense | SQL SSMS. From scratch to advanced levels.

Class location

About Lavanya

About the class

Rates

Rate

Pack prices

Travel

free classes

online

Similar Databases teachers in Calgary

Senior data analytics engineer || iiit-d m.tech cse(artificial intelligence) || gate: 99+%ile|| database, sql, machine learning, data analysis, programming || projects & assignments || 5 years of exp

Learn database concepts in depth using any of the database software like oracle, ms access, mysql, with hands on practice. taught by a corporate trainer in global market, ex-computer science professor

Data science, ai & data analysis trainer | 16+ years experience | practical & easy learning approach

M.tech in data science from iiit-b || unlock the potential of databases with personalized lessons from an experienced expert. dive deep into oracle, ms access, mysql, and sql queries.

Computer science engineer with ai/ml specialization teaching data analysis, databases, mysql, oracle, and informix using practical, industry-oriented methods

Professional senior data analyst and teaches mysql, python, tableau for data analyst enthusiast and makes you stand out.

Learn complete sql from beginner to advanced with interview prep | one-on-one from accenture data engineer

Learn in demand programming skills and data analysis in python, mining, sql from a professional software engineer having 3000+ hours of teaching experience.

8 plus years of experience | learn data analytics and data science from an industry expert having 7+ years of experience in data science, data analysis, machine learning, and programming.

Sql || professional engineer with 6 years of teaching experience gives computer related subjects sessions to students.

Learn sql queries and database. also get some project assistant and solve your assignments.

Data analytics trainer | sql | power bi | python | excel | job ready in 60 days

Data scientist ||python/c/c++ || data structures & algorithms || computer science || 1:1 classes & interview prep.

Embark on a journey to data science excellence - seasoned instructor with a master's in computer applications and 5+ years of teaching. i specialize in guiding beginners and kids through data science

Data engineering & data modelling training | beginner to advanced from 18+ years experience

Certified java and python instructor gives tuition from high school to college

Data analysis & database skills that get you hired - learn data analysis + sql databases practically

Cs tutor with 3+ years corporate experience, mdu postgrad, phd scholar—bridging theory and practice for smarter tech learning!

Iiitd mtech cse || software engineer || databases || sql || mysql || postgresql || nosql & others || gate exam 99%ile || programming || problem solving skills

Grasp the concepts, coding, data structures and transform your learning & coursework for igcse, ibdp, ap - computer science, python, java, ict applications (oop, data structures, boolean algebra, sql)

Senior Data Analyst | Power BI | Qlik Sense | SQL SSMS. From scratch to advanced levels.

Class location

About Lavanya

About the class

Rates

Rate

Pack prices

Travel

free classes

online

Similar Databases teachers in Calgary

Senior data analytics engineer || iiit-d m.tech cse(artificial intelligence) || gate: 99+%ile|| database, sql, machine learning, data analysis, programming || projects & assignments || 5 years of exp

Learn database concepts in depth using any of the database software like oracle, ms access, mysql, with hands on practice. taught by a corporate trainer in global market, ex-computer science professor

Data science, ai & data analysis trainer | 16+ years experience | practical & easy learning approach

M.tech in data science from iiit-b || unlock the potential of databases with personalized lessons from an experienced expert. dive deep into oracle, ms access, mysql, and sql queries.

Computer science engineer with ai/ml specialization teaching data analysis, databases, mysql, oracle, and informix using practical, industry-oriented methods

Professional senior data analyst and teaches mysql, python, tableau for data analyst enthusiast and makes you stand out.

Learn complete sql from beginner to advanced with interview prep | one-on-one from accenture data engineer

Learn in demand programming skills and data analysis in python, mining, sql from a professional software engineer having 3000+ hours of teaching experience.

8 plus years of experience | learn data analytics and data science from an industry expert having 7+ years of experience in data science, data analysis, machine learning, and programming.

Sql || professional engineer with 6 years of teaching experience gives computer related subjects sessions to students.

Learn sql queries and database. also get some project assistant and solve your assignments.

Data analytics trainer | sql | power bi | python | excel | job ready in 60 days

Data scientist ||python/c/c++ || data structures & algorithms || computer science || 1:1 classes & interview prep.

Embark on a journey to data science excellence - seasoned instructor with a master's in computer applications and 5+ years of teaching. i specialize in guiding beginners and kids through data science

Data engineering & data modelling training | beginner to advanced from 18+ years experience

Certified java and python instructor gives tuition from high school to college

Data analysis & database skills that get you hired - learn data analysis + sql databases practically

Cs tutor with 3+ years corporate experience, mdu postgrad, phd scholar—bridging theory and practice for smarter tech learning!

Iiitd mtech cse || software engineer || databases || sql || mysql || postgresql || nosql & others || gate exam 99%ile || programming || problem solving skills

Grasp the concepts, coding, data structures and transform your learning & coursework for igcse, ibdp, ap - computer science, python, java, ict applications (oop, data structures, boolean algebra, sql)

Share

Tutor profile verified

levels

All languages in which the class is available

Review

Reviews

Recommendations

free classes

Report this posting