About kalyan k:
Business Intelligence Analyst
Experience
- Generated PowerBI dashboards with advanced page/global filters, parameters and calculated fields that allowed tracking projected KPI for product performance, and customer interactions.
- Creating a re-usable Data Models for reusability and to implement the single version of truth.
- Experience in migrating the Excel reports into Power BI Solution.
- Experience in data cleansing using Power Query (M-Code) and transforming the data to fit for the reporting structure.
- Experience in writing or enhancing the M-code by creating functions for reusability.
- Creating different reports like Summary Reports, detailed reports like Drill-through, Drill-down and dynamic Page navigation reports.
- Creating complex DAX Measures, Calculated Columns and Calculated Tables.
- Creating reports with bookmarks, page navigation and dynamically hiding visuals for better user visual experience.
Education
- Collaborated closely with internal stakeholders to gather information related to production problems, projects, or user queries.
- Responded to specific BI requests from business development personnel, creating reports with requested information in easily understandable formats.
- Perform end to end analysis of Data using various tools and technologies.
- Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.
- Developed data reconciliation SQL queries to validate the overall data migration.
- Extracted data from Oracle, SQL Server, Flat Files, Excel, and XML using SSIS and cleanse the data.
- Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
- Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
- Analysed the data using Statistical features in Power BI to develop trend analysis.
- Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
- Programming tasks- Advance Dynamic SQL, Stored Procedures, Indexed Views, Functions and CTEs using T-SQL.
- Responsible for creating Company core business KPIs and Executive Dashboards for board members by just not showing the numbers but making a Data Story about it.
- Creating Technical Documentation and providing Power BI training to users for creating their own dashboards in Power BI Service.
- Experience in using external tools like DAX Studio, Tabular Editor, ALM Tool kit and Bravo.
Professionals in the same Technology / Internet sector as kalyan k
Professionals from different sectors near Scarborough, Ontario
Other users who are called kalyan
Jobs near Scarborough, Ontario
-
Program Performance Advisor Independent Electricity System Operator Location: Ontario Category:
Found in: Jooble CA O C2 - 1 day ago
Electricenergyonline Toronto, ON, CanadaThe opportunity · The Program Performance Advisor is responsible for the design, delivery, and continuous improvement of demand side management programs for the IESO, including Save on Energy programs, to address the needs of Ontario's power system and electricity consumers. Und ...
-
Maintenance Mechanic- Millwright
Found in: Talent CA C2 - 3 days ago
Apollo Health And Beauty Care Toronto, Canada Full timeApollo Health & Beauty Care (Apollo) is a premium developer of private label and control label health & beauty care products and leverages unique expertise and experience in developing national brand-equivalent products designed to compete equivalently with the most popular natio ...
-
Site Supervisor
Found in: Talent CA 2A C2 - 5 days ago
The Fathom Talent Group - Recruiting Experts Greater Toronto Area, CanadaTitle: Site Superintendent for a construction company · Base Salary: $120,000-125,000+ · Variable/Bonus: $14,000-15,000+ · Reporting to: General Superintendent · Direct Reports: 0 · Matrix: 30+ (Trades/End User Staff/Subcontractor/employees) · Key Performance Indicators · Safet ...