Varsham Papikian
Principal Database Architect and DBA at Wolters Kluwer Financial Services
Boston, Massachusetts, United States
Actions
I am a data enthusiast with over 25 years of experience in data processing, database management and associated Microsoft technologies. I specialize in delivering high-quality solutions in data processing, database management, performance tuning, scaling, automation, business intelligence, and analytics. My extensive expertise includes working on numerous projects using SQL Server, SSIS, SSRS, SSAS, Power BI, Power Query, Python, R and PowerShell. As a speaker and mentor, I am passionate about sharing my knowledge and helping others to succeed. I played a key role in starting the Boston Business Intelligence user group, and I have also helped to run the New England SQL Server user group.
Area of Expertise
Topics
Mastering Power BI: From Data to Insights
Microsoft Power BI is one of the fastest growing business intelligence tools on the market. In this presentation, we'll show you how to use Power BI to turn your data into valuable insights.
We'll start by exploring the expansive Power BI Ecosystem. Next, we'll dive into Power Query, a powerful data cleaning and transformation tool that can help you get your data into shape quickly and easily.
Once your data is ready, we'll show you how to create a robust data model and add custom measures. With Power BI's intuitive drag-and-drop interface, we'll build stunning interactive visuals, reports, and dashboards that can help you gain insights into your data.
Finally, we'll discuss how to share your insights with others.
This is an introductory session, so no prior knowledge of Power BI is required.
Mastering Power Query: Transform Data Like a Pro
Data preparation can be a time-consuming and challenging task and organizations spend a significant amount of time to clean and prepare data for analysis. Microsoft's Power Query is a powerful ETL tool which helps to transform and prepare data with ease. Whether you're a data analyst, scientist, or business user, mastering Power Query is a valuable skill that can help streamline your workflows.
In this presentation, we'll explore how to use Power Query to save time and gain valuable insights. We'll start by introducing the rich and intuitive interface of Power Query Editor in Power BI Desktop where you can perform complex transformations quickly and easily. We will also discuss how to use the underlying M language when extra flexibility is needed.
Throughout the presentation, we'll cover various topics, such as parameters, error handling, exploring data, query folding, and best practices. Finally, we'll discuss how to overcome some of the tool's limitations by using custom Python scripts.
To make the content more accessible, we'll provide multiple examples that demonstrate the concepts we discuss.
By the end of the presentation, you'll be well-equipped to start your own Power Query journey. So join my presentation and get ready to take your data preparation skills to the next level.
Mastering Azure Data Studio: Maximize Your Productivity
Azure Data Studio is a powerful, cross-platform database tool that is quickly gaining popularity among data professionals.
In this demo-heavy session, we'll show you why you should consider using it, how to use it, and how to extend and customize it to fit your needs.
While Azure Data Studio has many unique features, it's also helpful to understand how it compares to other database management tools like SQL Server Management Studio (SSMS): by highlighting the differences, we'll show you why Azure Data Studio is a valuable tool for any data professional.
One of the standout features of Azure Data Studio is Notebooks so we will demonstrate how to use Notebooks to streamline your workflow and make collaboration with others easier than ever.
This is an introductory session, so we won't be able to cover all the features in Azure Data Studio. However, we hope to provide you with enough information so that you could start your own journey and unlock the full potential of this powerful tool.
Mastering Data Transformation: Unleash the Potential of Power Query and M Language
In today's data-driven world, data transformation skills are no longer a luxury but a necessity. Data is the key ingredient for insights, decision-making, and innovation. However, unlocking its potential requires careful preparation, especially as data streams in from myriad external sources sometimes beyond our control or trust.
Meet Power Query — an established ETL (Extract, Transform and Load) powerhouse, offering a robust solution to conquer diverse data transformation challenges effortlessly.
Whether you're just a beginner or a seasoned pro, join us to unlock the full potential of Power Query and dive deep into the world of M Language.
We will start by covering the essential fundamentals of data transformation and navigating the intuitive Power Query interface.
From there, we ascend to advanced techniques and industry best practices, brought to life through real-world scenarios.
Through a series of hands-on demonstrations, we'll tackle the very data manipulation tasks you encounter daily, empowering you to streamline your workflows with confidence.
By the session's end, you'll not only witness the sheer power of Power Query and M Language but also acquire enough knowledge to embark on your transformative journey.
So, gear up to revolutionize your data handling capabilities and elevate your ETL proficiency to unprecedented heights.
SQL Saturday Boston 2023 Sessionize Event
Boston Code Camp 34 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top