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
Power BI: take your skills to the next level
If you already know Power BI basics and you are ready to dive deeper then this session is for you!
I will quickly describe the Power BI ecosystem. Then we will dive deeper and discuss intermediate/advanced features in Power Query (M language), parameters, AI-infused features, visuals, data modeling, DAX and certain performance aspects. Most of the features discussed won't require Power BI cloud service and they will work in Power BI Desktop which is FREE.
I hope that after the session many of you will stop just experimenting with Power BI and you will start achieving real results.
Power BI gets 'smarter': infuse more AI and ML into your BI processes
Power BI gets better every day. In addition to supporting R and Python, it gets more AI/ML features ready to use with very little effort - either right 'out-of-box' or as a result of easy integration with relevant Azure services. And this is just the beginning since Microsoft has recently assigned a dedicated AI team to enhance AI capabilities in Power BI so we should expect much more in coming months.
During the session I will describe the Power BI ecosystem and AI/ML in general. Then we will discuss existing and new 'out-of-box' AI features which are easy to use. I hope it will help you to master 'smarter' approaches and help to start exploring and applying predictive analyses to your processes. Stop only asking questions like 'What happened?' - start asking new new type of questions like 'What will happen next?'. Achieve more by using AI-infused features like Q&A, Insights and Web search by example.
SSMS Unlocked: Power Features You’re Not Using
With Azure Data Studio discontinued, SSMS (SQL Server Management Studio) is the undisputed king for SQL Server developers and administrators. Its reign is cemented by the new SSMS 21, which introduces a 64-bit architecture and newer VS 2022 Shell making it even more powerful and responsive.
But are you using it to its full potential? Most of us have been using SSMS for years, yet we only scratch the surface of its capabilities.
This 100% demo-packed session is designed for all skill levels. We will demo productivity hacks and "hidden in plain sight" features that will make you more productive.
You will leave with tricks which you will be using every single day. Also prepare for a few "Aha!" moments.
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